/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50613
 Source Host           : localhost
 Source Database       : springwind

 Target Server Type    : MySQL
 Target Server Version : 50613
 File Encoding         : utf-8

 Date: 03/30/2017 22:25:49 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `permission`
-- ----------------------------
DROP TABLE IF EXISTS `permission`;
CREATE TABLE `permission` (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `pid` bigint(20) NOT NULL DEFAULT '0' COMMENT '上级ID',
  `title` varchar(30) COLLATE utf8_bin NOT NULL COMMENT '标题',
  `type` smallint(6) NOT NULL DEFAULT '0' COMMENT '类型 0、菜单 1、功能',
  `state` smallint(6) NOT NULL DEFAULT '0' COMMENT '状态 0、正常 1、禁用',
  `sort` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `url` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '地址',
  `permCode` varchar(30) COLLATE utf8_bin DEFAULT NULL COMMENT '权限编码',
  `icon` varchar(30) COLLATE utf8_bin DEFAULT NULL COMMENT '图标',
  `description` varchar(80) COLLATE utf8_bin NOT NULL COMMENT '描述',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='权限表';

-- ----------------------------
--  Records of `permission`
-- ----------------------------
BEGIN;
INSERT INTO `permission` VALUES ('2', '0', '权限管理', '0', '0', '2', '/perm/', '2000', 'fa fa-eye', '权限管理'), ('1', '0', '功能管理', '0', '0', '1', '/sys/', '1000', 'fa fa-magic', '功能管理'), ('3', '0', '系统监控', '0', '0', '3', '/monitor/', '3000', 'fa fa-bar-chart-o', '系统监控'), ('4', '0', '操作日志', '0', '0', '4', '/log/', '4000', 'fa fa-bug', '操作日志'), ('11', '1', '发送邮件测试', '0', '0', '1', '/sys/mail/send.html', '1001', null, '发送邮件测试'), ('12', '1', 'Echarts 测试', '0', '0', '2', '/sys/echarts/map.html', '1002', null, '暂无2'), ('21', '2', '用户管理', '0', '0', '1', '/perm/user/list.html', '2001', null, '用户管理'), ('22', '2', '角色管理', '0', '0', '2', '/perm/role/list.html', '2002', null, '角色管理'), ('23', '2', '权限管理', '0', '0', '3', '/perm/permission/list.html', '2003', null, '权限管理'), ('31', '3', '警告列表', '0', '0', '1', 'abc.html', '3001', null, '警告列表'), ('32', '3', '实时监控', '0', '0', '2', '/monitor/realTime.html', '3002', null, '实时监控'), ('41', '4', '日志列表', '0', '0', '1', '/log/list.html', '4001', null, '日志列表');
COMMIT;

-- ----------------------------
--  Table structure for `role`
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `name` varchar(30) NOT NULL COMMENT '角色',
  `sort` smallint(6) NOT NULL DEFAULT '0' COMMENT '排序',
  `description` varchar(60) NOT NULL COMMENT '描述',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色表';

-- ----------------------------
--  Records of `role`
-- ----------------------------
BEGIN;
INSERT INTO `role` VALUES ('1', '管理员', '1', '系统管理员'), ('2', '普通会员', '2', '普通会员');
COMMIT;

-- ----------------------------
--  Table structure for `role_permission`
-- ----------------------------
DROP TABLE IF EXISTS `role_permission`;
CREATE TABLE `role_permission` (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `rid` bigint(20) NOT NULL COMMENT '角色ID',
  `pid` bigint(20) NOT NULL COMMENT '权限ID',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='角色权限表';

-- ----------------------------
--  Records of `role_permission`
-- ----------------------------
BEGIN;
INSERT INTO `role_permission` VALUES ('1', '1', '1'), ('2', '1', '2'), ('3', '1', '3'), ('4', '1', '4'), ('5', '1', '11'), ('6', '1', '12'), ('7', '1', '21'), ('8', '1', '22'), ('9', '1', '23'), ('10', '1', '31'), ('11', '1', '32'), ('12', '1', '41'), ('13', '2', '2'), ('14', '2', '21'), ('15', '2', '3'), ('16', '2', '31'), ('17', '2', '32');
COMMIT;

-- ----------------------------
--  Table structure for `sys_log`
-- ----------------------------
DROP TABLE IF EXISTS `sys_log`;
CREATE TABLE `sys_log` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `uid` bigint(20) unsigned DEFAULT NULL COMMENT '用户ID',
  `content` varchar(600) NOT NULL DEFAULT '' COMMENT '日志内容',
  `operation` varchar(250) DEFAULT NULL COMMENT '用户操作',
  `crTime` datetime NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=845202661338755073 DEFAULT CHARSET=utf8 COMMENT='操作日志表';

-- ----------------------------
--  Records of `sys_log`
-- ----------------------------
BEGIN;
INSERT INTO `sys_log` VALUES ('423827573609332736', null, '[类名]:com.baomidou.springwind.service.impl.UserServiceImpl,[方法]:selectByLoginName,[参数]:password=abc&loginName=abc&,[IP]:10.10.10.10', '登录', '2016-05-09 21:55:10'), ('423827889272651776', null, '[类名]:com.baomidou.springwind.service.impl.UserServiceImpl,[方法]:selectByLoginName,[参数]:password=abc&loginName=admin&,[IP]:10.10.10.10', '登录', '2016-05-09 21:56:23'), ('423828945075437568', null, '[类名]:com.baomidou.springwind.service.impl.UserServiceImpl,[方法]:selectByLoginName,[参数]:password=acbbb&repassword=acbbb&loginName=acbbb&,[IP]:10.10.10.10', '登录', '2016-05-09 22:00:37'), ('423828960116211712', null, '[类名]:com.baomidou.springwind.service.impl.UserServiceImpl,[方法]:insertSelective,[参数]:password=acbbb&repassword=acbbb&loginName=acbbb&,[IP]:10.10.10.10', '添加用户', '2016-05-09 22:00:40'), ('423829494923526144', null, '[类名]:com.baomidou.springwind.service.impl.UserServiceImpl,[方法]:selectByLoginName,[参数]:password=abc&loginName=admin&,[IP]:10.10.10.10', '登录', '2016-05-09 22:02:48'), ('423829536409387008', null, '[类名]:com.baomidou.springwind.service.impl.UserServiceImpl,[方法]:selectByLoginName,[参数]:password=abc&loginName=admin&,[IP]:10.10.10.10', '登录', '2016-05-09 22:02:58'), ('423829555678019584', null, '[类名]:com.baomidou.springwind.service.impl.UserServiceImpl,[方法]:selectByLoginName,[参数]:password=123&loginName=admin&,[IP]:10.10.10.10', '登录', '2016-05-09 22:03:02'), ('423829597029662720', '1', '[类名]:com.baomidou.springwind.service.impl.UserServiceImpl,[方法]:deleteUser,[参数]:null,[IP]:10.10.10.10', '删除用户', '2016-05-09 22:03:12'), ('423829597029662721', '1', '[类名]:com.baomidou.springwind.service.impl.UserServiceImpl,[方法]:deleteUser,[参数]:null,[IP]:10.10.10.10', '删除用户', '2016-05-09 22:03:12'), ('424204895713755136', null, '[类名]:com.baomidou.springwind.service.impl.UserServiceImpl,[方法]:selectByLoginName,[参数]:password=123&,[IP]:10.10.10.10', '登录', '2016-05-10 22:54:30'), ('424204946615828480', null, '[类名]:com.baomidou.springwind.service.impl.UserServiceImpl,[方法]:selectByLoginName,[参数]:password=abc&loginName=admin&,[IP]:10.10.10.10', '登录', '2016-05-10 22:54:42'), ('424204971169284096', null, '[类名]:com.baomidou.springwind.service.impl.UserServiceImpl,[方法]:selectByLoginName,[参数]:password=123&loginName=admin&,[IP]:10.10.10.10', '登录', '2016-05-10 22:54:48'), ('424212917953495040', null, '[类名]:com.baomidou.springwind.service.impl.UserServiceImpl,[方法]:selectByLoginName,[参数]:password=123&,[IP]:10.10.10.10', '登录', '2016-05-10 23:26:23'), ('424213509627183104', null, '[类名]:com.baomidou.springwind.service.impl.UserServiceImpl,[方法]:selectByLoginName,[参数]:password=123&,[IP]:10.10.10.10', '登录', '2016-05-10 23:28:44'), ('424213551029157888', null, '[类名]:com.baomidou.springwind.service.impl.UserServiceImpl,[方法]:selectByLoginName,[参数]:password=123&loginName=admin&,[IP]:10.10.10.10', '登录', '2016-05-10 23:28:54'), ('424538597211766784', null, '[类名]:com.baomidou.springwind.service.impl.UserServiceImpl,[方法]:selectByLoginName,[参数]:password=abc&loginName=abc&,[IP]:10.10.10.10', '登录', '2016-05-11 21:00:31'), ('424538650328432640', null, '[类名]:com.baomidou.springwind.service.impl.UserServiceImpl,[方法]:selectByLoginName,[参数]:password=abc&loginName=admin&,[IP]:10.10.10.10', '登录', '2016-05-11 21:00:44'), ('424538669534150656', null, '[类名]:com.baomidou.springwind.service.impl.UserServiceImpl,[方法]:selectByLoginName,[参数]:password=abc&loginName=admin&,[IP]:10.10.10.10', '登录', '2016-05-11 21:00:48'), ('424538690912518144', null, '[类名]:com.baomidou.springwind.service.impl.UserServiceImpl,[方法]:selectByLoginName,[参数]:password=123&loginName=admin&,[IP]:10.10.10.10', '登录', '2016-05-11 21:00:53'), ('424538709661057024', null, '[类名]:com.baomidou.springwind.service.impl.UserServiceImpl,[方法]:selectByLoginName,[参数]:password=123&,[IP]:10.10.10.10', '登录', '2016-05-11 21:00:58'), ('424538725716852736', null, '[类名]:com.baomidou.springwind.service.impl.UserServiceImpl,[方法]:selectByLoginName,[参数]:password=123&,[IP]:10.10.10.10', '登录', '2016-05-11 21:01:02'), ('843795631839318016', null, '[类名]:com.baomidou.springwind.service.impl.UserServiceImpl,[方法]:selectByLoginName,[参数]:captcha=7esw&ctoken=f95924f3fb304c728fc55599a8270600&password=123&loginName=admin&,[IP]:192.168.1.105', '登录', '2017-03-20 20:05:30'), ('844175330184740864', null, '[类名]:com.baomidou.springwind.service.impl.UserServiceImpl,[方法]:selectByLoginName,[参数]:captcha=7x23&ctoken=acc90056ef1a4e3d81896f8c82b38e2d&password=123&loginName=admin&,[IP]:192.168.1.105', '登录', '2017-03-21 21:14:17'), ('844187979190595584', null, '[类名]:com.baomidou.springwind.service.impl.UserServiceImpl,[方法]:selectByLoginName,[参数]:password=123&,[IP]:192.168.1.105', '登录', '2017-03-21 22:04:33'), ('845202661338755072', null, '[类名]:com.baomidou.springwind.service.impl.UserServiceImpl,[方法]:selectByLoginName,[参数]:captcha=5wm6&ctoken=0d6fa45e74cd4bffa31d0092284d51b9&password=123&loginName=admin&,[IP]:192.168.1.100', '登录', '2017-03-24 17:16:32');
COMMIT;

-- ----------------------------
--  Table structure for `tb_app`
-- ----------------------------
DROP TABLE IF EXISTS `tb_app`;
CREATE TABLE `tb_app` (
  `tbid` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '图标名称',
  `icon` tinytext COLLATE utf8_unicode_ci COMMENT '图标图片',
  `url` tinytext COLLATE utf8_unicode_ci COMMENT '图标链接',
  `type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '应用类型，app（窗口应用）widget（挂件应用）',
  `width` int(11) DEFAULT NULL COMMENT '窗口宽度',
  `height` int(11) DEFAULT NULL COMMENT '窗口高度',
  `isresize` tinyint(1) DEFAULT NULL COMMENT '是否能对窗口进行拉伸，1（是）0（否）',
  `isopenmax` tinyint(1) DEFAULT NULL COMMENT '是否打开直接最大化，1（是）0（否）',
  `issetbar` tinyint(1) DEFAULT NULL COMMENT '窗口是否有评分和介绍按钮，1（是）0（否）',
  `isflash` tinyint(1) DEFAULT NULL COMMENT '是否为flash应用，1（是）0（否）',
  `remark` longtext COLLATE utf8_unicode_ci COMMENT '备注',
  `usecount` bigint(20) DEFAULT '0' COMMENT '使用人数',
  `starnum` double DEFAULT '0' COMMENT '评分',
  `dt` datetime DEFAULT NULL COMMENT '添加时间',
  `isrecommend` tinyint(1) DEFAULT '0' COMMENT '是否推荐，1（是）0（否）',
  `verifytype` tinyint(1) DEFAULT '0' COMMENT '审核状态，0（未提交审核）1（审核通过）2（审核中）3（审核不通过）',
  `verifyinfo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '审核提示信息',
  `app_category_id` bigint(20) DEFAULT '0' COMMENT '应用类目id',
  `member_id` bigint(20) DEFAULT '0' COMMENT '用户id',
  PRIMARY KEY (`tbid`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
--  Records of `tb_app`
-- ----------------------------
BEGIN;
INSERT INTO `tb_app` VALUES ('1', '应用管理', '/static/uploads/shortcut/20130505/13677343655235.png', '/sysapp/appmanage/index.html', 'window', '900', '650', '0', '0', '0', '0', '', '0', '0', '2012-02-26 22:51:53', '0', '1', null, '1', '0'), ('2', '网站设置', '/static/img/ui/system-gear.png', '/sysapp/websitesetting/index.html', 'window', '900', '550', '0', '0', '0', '0', '', '0', '0', '2012-02-26 22:52:40', '0', '1', null, '1', '0'), ('3', '会员管理', '/static/img/ui/system-users.png', '/sysapp/member/index.html', 'window', '900', '550', '0', '0', '0', '0', '', '0', '0', '2012-07-19 10:57:28', '0', '1', null, '1', '0'), ('4', '权限管理', '/static/img/ui/system-puzzle.png', '/sysapp/permission/index.html', 'window', '900', '550', '0', '0', '0', '0', '', '0', '0', '2012-07-19 10:59:41', '0', '1', null, '1', '0'), ('5', '类目管理', '/static/img/ui/system-puzzle.png', '/sysapp/category/index.html', 'window', '900', '550', '0', '0', '0', '0', '', '0', '0', '2012-07-19 11:11:41', '0', '1', null, '1', '0'), ('6', '豆瓣FM', '/static/uploads/shortcut/20130505/13677359545258.png', 'http://douban.fm/partner/webqq?fromhoorayos', 'window', '420', '240', '0', '0', '1', '0', '豆瓣FM', '0', '0', '2012-02-26 22:52:03', '0', '1', null, '3', '0'), ('7', '三维地图', '/static/uploads/shortcut/20130505/136773428052.png', 'http://sz.chachaba.com/api20110914.html', 'window', '1050', '550', '1', '0', '1', '1', '三维地图', '0', '0', '2012-02-26 22:52:55', '0', '1', null, '6', '0'), ('8', '美图秀秀', '/static/uploads/shortcut/20130505/13677342371591.png', 'http://xiuxiu.web.meitu.com/qq/web/', 'window', '900', '620', '1', '0', '1', '1', '美图秀秀', '0', '0', '2012-02-26 22:52:58', '0', '1', null, '6', '0'), ('9', '非诚勿扰', '/static/uploads/shortcut/20130505/13677343281639.png', 'http://v.56.com/API/app/baidu/tv/index.php?mid=6085&canvas_pos=search&custom=1&bd_user=553916098&bd_', 'window', '800', '480', '0', '0', '1', '1', '非诚勿扰', '0', '0', '2012-02-26 22:52:24', '0', '1', null, '3', '0'), ('10', '搜狐视频', '/static/uploads/shortcut/20130505/13677343162518.png', 'http://tv.sohu.com/upload/sohuapp/index.html?api_key=9ca7e3cdef8af010b947f4934a427a2c', 'window', '840', '730', '0', '0', '1', '1', '搜狐视频', '0', '0', '2012-02-26 22:52:26', '0', '1', null, '3', '0'), ('11', '迅雷看看', '/static/uploads/shortcut/20130505/13677342975360.gif', 'http://recommend.xunlei.com/channel_360_v2/index.html?from=webqq', 'window', '960', '370', '0', '0', '1', '1', '迅雷看看', '0', '0', '2012-02-26 22:52:29', '0', '1', null, '3', '0'), ('12', '时钟', '/static/img/ui/system-shapes.png', '/extapp/clock/index.html', 'widget', '130', '160', '0', '0', '1', '0', '时钟', '0', '0', '2012-08-05 23:01:51', '0', '1', null, '6', '0'), ('13', '天气预报', '/static/img/ui/system-shapes.png', '/extapp/weather/index.html', 'widget', '200', '330', '0', '0', '1', '0', '天气预报', '0', '0', '2012-08-05 23:02:28', '0', '1', null, '6', '0'), ('14', '日历', '/static/uploads/shortcut/20130505/13677342114330.png', '/sysapp/calendar/index.html', 'window', '800', '720', '1', '0', '1', '0', '', '9', '0', '2012-10-16 03:06:17', '1', '1', null, '6', '0'), ('15', '狙击手密室逃脱', '/static/uploads/shortcut/20130505/13677340436355.png', 'http://www.4399.com/360game/86190.htm', 'window', '820', '680', '1', '0', '1', '1', '操作方法: 游戏中使用鼠标操作，点击物品触发事件。 如何开始: 游戏加载完毕点击PLAY即可开始游戏\r\n狙击手被困在了一个藏有枪支的房间，不擅长动脑的他需要你的帮助，根据提示找到房间的', '0', '0', '2013-05-05 14:07:28', '0', '1', null, '2', '0'), ('16', '英雄激战怪物', '/static/uploads/shortcut/20130505/13677346104517.png', 'http://www.4399.com/360game/86244.htm', 'window', '820', '680', '1', '0', '1', '1', '操作方法: 游戏开始后拖动人物调整阵形，然后点击下方的英文，再点击攻击目标即可开始战斗。下方有各种道具哦！ ', '0', '0', '2013-05-05 14:17:14', '0', '1', null, '2', '0'), ('17', '眼球大战', '/static/uploads/shortcut/20130505/13677346716160.png', 'http://www.4399.com/360game/86238.htm', 'window', '820', '680', '1', '0', '1', '1', '操作方法: 键盘方向键←→控制移动，空格键发射眼药水。 如何开始: 游戏加载完毕点击[开始]即可开始游戏', '0', '0', '2013-05-05 14:18:09', '0', '1', null, '2', '0'), ('18', '朵拉的烧烤店', '/static/uploads/shortcut/20130505/13677347227549.png', 'http://www.4399.com/360game/86215.htm', 'window', '820', '680', '1', '0', '1', '1', '操作方法: 鼠标点击食材放到烤架上，点击食物翻到另一面，烤熟后拿给顾客吃，别忘了收钱哦。如何开始: 游戏加载完毕点击三次[开始游戏] - 再点击[确定]即可开始游戏', '0', '0', '2013-05-05 14:19:48', '0', '1', null, '2', '0'), ('19', '泡泡兔2', '/static/uploads/shortcut/20130505/13677349543577.png', 'http://www.4399.com/360game/86180.htm', 'window', '820', '680', '1', '0', '1', '1', '操作方法: 玩家一：键盘AD键控制移动，W键跳跃(可二段跳)，空格键放泡泡(会爆炸)。 玩家二：方向键←→控制移动，↑键跳跃(可二段跳)，小键盘数字键0放泡泡(会爆炸)。 提示：单人模式选择', '0', '0', '2013-05-05 14:23:02', '0', '1', null, '2', '0'), ('20', '猫和老鼠之万圣之夜', '/static/uploads/shortcut/20130505/13677350213580.png', 'http://www.4399.com/360game/86176.htm', 'window', '820', '680', '1', '0', '1', '1', '操作方法: 游戏中使用空格键控制老鼠跳跃，不要被猫抓到了哦。 如何开始: 游戏加载完毕点击两次PLAY即可开始游戏', '0', '0', '2013-05-05 14:24:01', '0', '1', null, '2', '0'), ('21', '小刺猬去面试', '/static/uploads/shortcut/20130505/1367735129442.png', 'http://www.4399.com/360game/86142.htm', 'window', '820', '680', '1', '0', '1', '1', '操作方法: 鼠标点击触发事件，帮助小刺猬解决遇到的问题，继续前行吧！ 如何开始: 游戏加载完成后点击continue - 再点击play即可开始游戏', '0', '0', '2013-05-05 14:26:00', '0', '1', null, '2', '0'), ('22', '黑猫警长救伙伴', '/static/uploads/shortcut/20130505/13677351957517.png', 'http://api.game.7k7k.com/360box/90173.html', 'window', '820', '680', '1', '0', '1', '1', '操作方法: 游戏中使用方向键进行推伙伴。 如何开始: 点击【进入游戏】--【开始】进行游戏。', '0', '0', '2013-05-05 14:27:00', '0', '1', null, '2', '0'), ('23', '部落争霸', '/static/uploads/shortcut/20130505/13677353369336.png', 'http://api.game.7k7k.com/360box/90130.html', 'window', '820', '680', '1', '0', '1', '1', '操作方法: 鼠标点击发兵。 如何开始: 点击play-点击start game-选择关卡1开始游戏。\r\n古老的部落之间充满了战争，都是为了生存下去，不想被别人吞并的话就努力发展下去吧。', '0', '0', '2013-05-05 14:29:18', '0', '1', null, '2', '0'), ('24', '愚人节整同学', '/static/uploads/shortcut/20130505/13677353829381.png', 'http://api.game.7k7k.com/360box/60422.html', 'window', '820', '680', '1', '0', '1', '1', '操作方法: 游戏中使用鼠标操作，点击道具整人。 如何开始: 输入你想整的人的名字后点击[开始整人]开始游戏。', '0', '0', '2013-05-05 14:30:07', '0', '1', null, '2', '0'), ('25', '优酷视频', '/static/uploads/shortcut/20130505/13677356058228.png', 'http://api.youku.com/widget/360box/index.html', 'window', '820', '680', '1', '0', '1', '1', '优酷专注发展主流大气的内容平台定位和专业化的频道运营战略，海量视频库实现垂直定向分类检索，引领互联网视频时代资讯、影视、娱乐综艺潮流。', '0', '0', '2013-05-05 14:33:48', '0', '1', null, '3', '0'), ('26', '2B青年必看的18禁电影', '/static/uploads/shortcut/20130505/13677356703430.png', 'http://recommend.xunlei.com/topic360_138.html', 'window', '980', '700', '1', '0', '1', '1', '迅雷看看推出2B青年必看的18禁电影', '0', '0', '2013-05-05 14:35:28', '0', '1', null, '3', '0'), ('27', '爱奇艺', '/static/uploads/shortcut/20130505/13677357888501.png', 'http://www.qiyi.com/mini/qplus.html', 'window', '1030', '720', '1', '0', '1', '1', '国内首家专注于提供免费、高清网络视频服务的大型专业网站。奇艺影视内容丰富多元，涵盖电影、电视剧、综艺、纪录片、动画片等热门剧目；视频播放清晰流畅，操作界面简单友好，真正为', '0', '0', '2013-05-05 14:37:16', '0', '1', null, '3', '0'), ('28', '土豆视频', '/static/uploads/shortcut/20130505/13677358555620.png', 'http://2010.tudou.com/360api/index.php', 'window', '1030', '800', '1', '0', '1', '1', '大型视频分享网站土豆网的桌面版，具有原创、电视剧、电影、综艺、排行等栏目，用户可以在该网站上传、观看、分享视频短片。', '0', '0', '2013-05-05 14:38:25', '0', '1', null, '3', '0'), ('29', '音悦台', '/static/uploads/shortcut/20130505/13677359969968.png', 'http://www.yinyuetai.com/webqq', 'window', '830', '520', '1', '0', '1', '1', '最新最全最高清的MV尽在音悦台，可以按照您的音乐喜好选择收看华语、日韩、欧美以及新歌首发频道。', '0', '0', '2013-05-05 14:40:33', '0', '1', null, '3', '0'), ('30', '酷狗电台', '/static/uploads/shortcut/20130505/13677361014197.png', 'http://topic.kugou.com/radio/', 'window', '780', '580', '1', '0', '1', '1', '基于酷狗音乐的网页音乐电台。具有海量的音乐资源以及各类超红榜单，在这里，酷狗的各个精彩音乐榜单为您带来前所未有的丰富音乐收听感受。高质量的音质让您重新感受音乐的魅力。', '0', '0', '2013-05-05 14:42:19', '0', '1', null, '3', '0'), ('31', '极品狂少混花都', '/static/uploads/shortcut/20130505/13677362198177.png', 'http://book.hjsm.tom.com/109696/360catelog.html', 'window', '1000', '650', '1', '0', '1', '0', '极品狂少混花都是由幻剑书盟提供的一款小说类的web app', '0', '0', '2013-05-05 14:44:27', '0', '1', null, '4', '0'), ('32', '异世之魔武传奇', '/static/uploads/shortcut/20130505/1367736387213.png', 'http://book.hjsm.tom.com/100201/360catelog.html', 'window', '1000', '650', '1', '0', '1', '0', '异世之魔武传奇是由幻剑书盟提供的一款小说类的web app', '0', '0', '2013-05-05 14:46:48', '0', '1', null, '4', '0'), ('33', '最强近卫', '/static/uploads/shortcut/20130505/13677364305280.png', 'http://book.hjsm.tom.com/107061/360catelog.html', 'window', '1000', '650', '1', '0', '1', '0', '最强近卫是由幻剑书盟提供的一款小说类的web app', '0', '0', '2013-05-05 14:47:28', '0', '1', null, '4', '0'), ('34', '校花保镖', '/static/uploads/shortcut/20130505/13677364692734.png', 'http://book.hjsm.tom.com/106665/360catelog.html', 'window', '1000', '650', '1', '0', '1', '0', '校花保镖是由幻剑书盟提供的一款小说类的web app', '0', '0', '2013-05-05 14:48:11', '0', '1', null, '4', '0'), ('35', '我的制服女友', '/static/uploads/shortcut/20130505/13677365159802.png', 'http://book.hjsm.tom.com/110407/360catelog.html', 'window', '1000', '650', '1', '0', '1', '0', '我的制服女友是由幻剑书盟提供的一款小说类的web app', '0', '0', '2013-05-05 14:48:53', '0', '1', null, '4', '0'), ('36', '被妞泡的日子', '/static/uploads/shortcut/20130505/1367736560985.png', 'http://book.hjsm.tom.com/108669/360catelog.html', 'window', '1000', '650', '1', '0', '1', '0', '被妞泡的日子是由幻剑书盟提供的一款小说类的web app', '0', '0', '2013-05-05 14:49:39', '0', '1', null, '4', '0'), ('37', '极品小员工', '/static/uploads/shortcut/20130505/13677366172043.png', 'http://book.hjsm.tom.com/109038/360catelog.html', 'window', '1000', '650', '1', '0', '1', '0', '极品小员工是由幻剑书盟提供的一款小说类的web app', '1', '0', '2013-05-05 14:50:41', '0', '1', null, '4', '0'), ('38', '异世御龙', '/static/uploads/shortcut/20130505/13677366722127.png', 'http://book.hjsm.tom.com/105977/360catelog.html', 'window', '1000', '650', '1', '0', '1', '0', '异世御龙是由幻剑书盟提供的一款小说类的web app', '0', '0', '2013-05-05 14:51:32', '0', '1', null, '4', '0'), ('39', '冷酷校草恋上我', '/static/uploads/shortcut/20130505/13677367421113.png', 'http://book.hjsm.tom.com/105522/360catelog.html', 'window', '1000', '650', '1', '0', '1', '0', '冷酷校草恋上我是由幻剑书盟提供的一款小说类的web app', '1', '0', '2013-05-05 14:52:43', '0', '1', null, '4', '0'), ('40', '赵子龙穿越到都市', '/static/uploads/shortcut/20130505/1367736867676.png', 'http://book.hjsm.tom.com/109405/360catelog.html', 'window', '1000', '650', '1', '0', '1', '0', '赵子龙穿越到都市是由幻剑书盟提供的一款小说类的web app', '0', '0', '2013-05-05 14:54:49', '0', '1', null, '4', '0'), ('41', '天气预报', '/static/uploads/shortcut/20130505/13677369315643.png', 'http://shenghuo.360.cn/tq/yb?360src=360se', 'window', '420', '680', '1', '0', '1', '0', '精美天气预报应用', '1', '0', '2013-05-05 14:56:07', '0', '1', null, '5', '0'), ('42', '快递查询', '/static/uploads/shortcut/20130505/13677370021209.png', 'http://www.kuaidi100.com/frame/qq/webqq/?canvas_pos=2016', 'window', '560', '460', '1', '0', '1', '0', '快递查询是友商网快递100开发的，提供海量的快递查询服务，涵盖近百家常用快递公司，查询无需验 证码，支持手机查快递，并为B2C等网络应用提供免费的快递查询接口API。', '0', '0', '2013-05-05 14:57:14', '0', '1', null, '5', '0'), ('43', '万年历', '/static/uploads/shortcut/20130505/1367737151617.png', 'http://www.saturdaysoft.com/prod/360apc/calendar.html', 'window', '540', '450', '0', '0', '1', '0', '方便易用的万年历应用，具有日历浏览方式，可以快速切换到相邻月份、跳转到指定年月或回到当天，具有详细准确的节日和节气信息，支持黄历、天气等功能。', '0', '0', '2013-05-05 14:59:42', '0', '1', null, '5', '0'), ('44', '城市间路程油费路桥费查询', '/static/uploads/shortcut/20130505/13677372407307.png', 'http://www.pcwcn.com/city_search?type=alone&bd_user=0&bd_sig=bb7229df73013a1a18f947b4c929e2b7', 'window', '560', '400', '0', '0', '1', '0', '两个城市之间的路程、开车时间、油费、路桥费查询工具。输入出发城市和目的城市，即可查询哦！本应用为拼车网（www.pcwcn.com）提供的一个实用生活类查询工具。我们的数据来源于拼车网，', '0', '0', '2013-05-05 15:01:22', '0', '1', null, '5', '0'), ('45', '手机充值', '/static/uploads/shortcut/20130505/13677373176723.png', 'http://shenghuo.360.cn/dapp', 'window', '540', '350', '0', '0', '1', '0', '具有省时、便捷、不受地域缴费充值的限制等优点。用户通过网上银行缴费，即可实现为手机号码充入话费，使用户不受银行营业时间、网点的限制，真正实现“随时随地”支付交易，享受轻松', '5', '0', '2013-05-05 15:02:36', '0', '1', null, '5', '0'), ('46', '身份证查询', '/static/uploads/shortcut/20130505/13677373916735.png', 'http://360app.45451.com/sfz', 'window', '580', '380', '0', '0', '1', '0', '身份证号码查询验证工具。可自动识别发证地、出生年月日、性别等信息，如果为15位身份证号，该软件可自动生成18位身份证号。', '0', '5', '2013-05-05 15:03:56', '0', '1', null, '5', '0'), ('47', '酷讯火车票', '/static/uploads/shortcut/20130505/13677375795763.png', 'http://n.huoche.kuxun.cn/?fromid=Kapc360cn-S1205011-T1183881', 'window', '790', '630', '0', '0', '1', '0', '酷讯火车票、特价机票查询平台。酷讯火车票平台，每年有2亿人使用，数据准确，更新及时，是国内最早，用户量最大的火车票转让平台之一。', '0', '0', '2013-05-05 15:07:01', '0', '1', null, '5', '0'), ('48', '减肥食谱', '/static/uploads/shortcut/20130505/1367737648336.png', 'http://www.pcbaby.com.cn/360/diet/', 'window', '820', '640', '0', '0', '1', '0', '太平洋亲子网制作的减肥食谱，在奉承以瘦为美的时代，推荐多种具有减肥功效的食谱，也提醒广大女性健康的减肥方法：“民以食为天”，减肥是靠饮食调理，而不是靠节食。', '0', '0', '2013-05-05 15:08:04', '0', '1', null, '5', '0'), ('49', '眼睛保健操', '/static/uploads/shortcut/20130505/13677377979610.png', 'http://apps.qiyigoo.com/yanbaojiancao/', 'window', '570', '600', '0', '0', '1', '0', '眼睛保健操，让眼镜休息一会。提供多种眼睛运动方式，根据自己的运动程度调节运动速度，还提供了一些常用的眼睛保健方法，包含：提高视力的方法，改善视力的食物，保护眼睛的方法。', '0', '0', '2013-05-05 15:10:24', '0', '1', null, '5', '0'), ('50', 'KTV大全', '/static/uploads/shortcut/20130505/13677378833444.png', 'http://www.51huoban.com/baidu/ktv/index.php', 'window', '560', '540', '0', '0', '1', '0', '最新最实用的ktv大全，想去哪唱K这里都有好介绍。根据自身不同的城市需要，点击选择不同的城市。查看城市KTV的相关信息。', '0', '0', '2013-05-05 15:11:58', '0', '1', null, '5', '0'), ('51', '语音计算器', '/static/uploads/shortcut/20130505/13677380592462.png', 'http://app.qiqi.cc/apps/video_calc/', 'window', '560', '530', '0', '0', '1', '1', '语音计算器除了实现普通的计算器功能之外，还具备了独特的语音发声技术；支持鼠标、键盘输入的功能，有助于加快计算时所需要的时间；支持计算出结果后继续计算的功能，操作方法跟系统', '0', '0', '2013-05-05 15:15:05', '0', '1', null, '6', '0'), ('52', '有道在线词典', '/static/uploads/shortcut/20130505/1367738149614.png', 'http://dict.youdao.com/app/360', 'window', '560', '560', '0', '0', '1', '0', '有道在线词典web版本。有道词典结合了互联网在线词典和桌面词典的优势，具备中英、英中、英英翻译、汉语词典功能。同时，创新的\"网络释义\"功能将各类新兴词汇和英文缩写收录其中。依托', '1', '0', '2013-05-05 15:16:30', '0', '1', null, '6', '0'), ('53', '交通标志', '/static/uploads/shortcut/20130505/13677384429066.png', 'http://cnzaobao.com/360se/jiaotongbiaozhi.html', 'window', '600', '700', '0', '0', '1', '1', '交通标志大全，安全出行好助手！ 熟记交通标志大全，为你考证，为你出行，为你安全提供极大的帮助。', '1', '0', '2013-05-05 15:21:17', '0', '1', null, '6', '0'), ('54', '秒表计时器', '/static/uploads/shortcut/20130505/13677387064869.png', 'http://5.app100672505.twsapp.com/bd_miaodao.php', 'window', '580', '440', '0', '0', '1', '0', '秒表功能精确到毫秒，在计时过程中可以计次，最多可计100次，点击复位重新初始化秒表；倒计时可以设置最长时间单位为小时的时间倒数，具有到点铃声提醒功能', '2', '0', '2013-05-05 15:25:53', '0', '1', null, '6', '0'), ('55', '阴历阳历转换', '/static/uploads/shortcut/20130505/13677388786.png', 'http://5.app100672505.twsapp.com/ada_yrzh/', 'window', '570', '470', '0', '0', '1', '0', '阴历阳历转换器，从你所知道的公历或者阳历转换成对应的农历或阴历；一键转换，方便快捷；阴历阳历转换器，程序自动判断年份中是否包含了闰月', '3', '0', '2013-05-05 15:28:30', '0', '1', null, '6', '0'), ('56', '新应用test', '/static/img/ui/system-star.png', 'http://m.onlinefix.cn', 'window', '570', '470', '1', '0', '1', '0', '应用测试', '2', '0', '2017-03-01 21:51:28', '0', '1', null, '2', '2');
COMMIT;

-- ----------------------------
--  Table structure for `tb_app_category`
-- ----------------------------
DROP TABLE IF EXISTS `tb_app_category`;
CREATE TABLE `tb_app_category` (
  `tbid` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '名称',
  `issystem` tinyint(1) DEFAULT '0' COMMENT '是否为系统类目，1（是）0（否）',
  PRIMARY KEY (`tbid`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
--  Records of `tb_app_category`
-- ----------------------------
BEGIN;
INSERT INTO `tb_app_category` VALUES ('1', '系统', '1'), ('2', '游戏', '0'), ('3', '影音', '0'), ('4', '图书', '0'), ('5', '生活', '0'), ('6', '工具', '0');
COMMIT;

-- ----------------------------
--  Table structure for `tb_app_star`
-- ----------------------------
DROP TABLE IF EXISTS `tb_app_star`;
CREATE TABLE `tb_app_star` (
  `tbid` bigint(20) NOT NULL AUTO_INCREMENT,
  `app_id` bigint(20) DEFAULT NULL COMMENT '应用id',
  `member_id` bigint(20) DEFAULT NULL COMMENT '用户id',
  `starnum` int(1) DEFAULT '0' COMMENT '评分',
  `dt` datetime DEFAULT NULL COMMENT '操作时间',
  PRIMARY KEY (`tbid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
--  Table structure for `tb_calendar`
-- ----------------------------
DROP TABLE IF EXISTS `tb_calendar`;
CREATE TABLE `tb_calendar` (
  `tbid` bigint(20) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '标题',
  `content` longtext COLLATE utf8_unicode_ci COMMENT '详细内容',
  `url` text COLLATE utf8_unicode_ci COMMENT '超链接',
  `startdt` datetime DEFAULT NULL COMMENT '开始时间',
  `enddt` datetime DEFAULT NULL COMMENT '结束时间',
  `isallday` tinyint(1) DEFAULT '1' COMMENT '是否属于全天任务',
  `member_id` bigint(20) DEFAULT NULL COMMENT '用户id',
  PRIMARY KEY (`tbid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
--  Table structure for `tb_member`
-- ----------------------------
DROP TABLE IF EXISTS `tb_member`;
CREATE TABLE `tb_member` (
  `tbid` bigint(20) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '用户名',
  `password` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '密码',
  `lockpassword` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '锁屏密码',
  `type` tinyint(1) DEFAULT '0' COMMENT '用户类型，0（普通用户）1（管理员）',
  `permission_id` bigint(20) DEFAULT NULL COMMENT '权限id',
  `dock` longtext COLLATE utf8_unicode_ci COMMENT '[应用码头]应用id，用","相连',
  `desk1` longtext COLLATE utf8_unicode_ci COMMENT '[桌面1]应用id，用","相连',
  `desk2` longtext COLLATE utf8_unicode_ci COMMENT '[桌面2]应用id，用","相连',
  `desk3` longtext COLLATE utf8_unicode_ci COMMENT '[桌面3]应用id，用","相连',
  `desk4` longtext COLLATE utf8_unicode_ci COMMENT '[桌面4]应用id，用","相连',
  `desk5` longtext COLLATE utf8_unicode_ci COMMENT '[桌面5]应用id，用","相连',
  `appxy` varchar(255) COLLATE utf8_unicode_ci DEFAULT 'x' COMMENT '图标排列方式，x（横向排列）y（纵向排列）',
  `desk` tinyint(1) DEFAULT '1' COMMENT '默认桌面',
  `dockpos` varchar(255) COLLATE utf8_unicode_ci DEFAULT 'top' COMMENT '应用码头位置，top（顶部）left（左侧）right（右侧）none（隐藏）',
  `appsize` int(11) DEFAULT '48' COMMENT '图标尺寸',
  `appverticalspacing` int(11) DEFAULT '50' COMMENT '图标垂直间距',
  `apphorizontalspacing` int(11) DEFAULT '50' COMMENT '图标水平间距',
  `wallpaper_id` int(11) DEFAULT '1' COMMENT '壁纸id',
  `wallpaperwebsite` text COLLATE utf8_unicode_ci COMMENT '壁纸网址',
  `wallpaperstate` tinyint(4) DEFAULT '1' COMMENT '1（系统壁纸）2（自定义壁纸）3（网络地址）',
  `wallpapertype` varchar(255) COLLATE utf8_unicode_ci DEFAULT 'juzhong' COMMENT '壁纸显示方式，tianchong（填充）shiying（适应）pingpu（平铺）lashen（拉伸）juzhong（居中）',
  `skin` varchar(255) COLLATE utf8_unicode_ci DEFAULT 'default' COMMENT '窗口皮肤',
  `regdt` datetime DEFAULT NULL COMMENT '注册时间',
  `lastlogindt` datetime DEFAULT NULL COMMENT '上次登录时间',
  `lastloginip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '上次登录IP',
  `thislogindt` datetime DEFAULT NULL COMMENT '本次登陆时间',
  `thisloginip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '本次登录IP',
  `openid_qq` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `openname_qq` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `openavatar_qq` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `openurl_qq` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `openid_sinaweibo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `openname_sinaweibo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `openavatar_sinaweibo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `openurl_sinaweibo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `openid_tweibo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `openname_tweibo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `openavatar_tweibo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `openurl_tweibo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `openid_t163weibo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `openname_t163weibo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `openavatar_t163weibo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `openurl_t163weibo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `openid_renren` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `openname_renren` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `openavatar_renren` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `openurl_renren` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `openid_baidu` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `openname_baidu` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `openavatar_baidu` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `openurl_baidu` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `openid_douban` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `openname_douban` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `openavatar_douban` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `openurl_douban` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`tbid`)
) ENGINE=InnoDB AUTO_INCREMENT=847112957359783937 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
--  Records of `tb_member`
-- ----------------------------
BEGIN;
INSERT INTO `tb_member` VALUES ('1', 'hoorayos', '7c4a8d09ca3762af61e59520943dc26494f8941b', 'c5e9fe42f061fa6102857db920734c33ec7b0816', '1', '1', '', '', '', '', '', '', 'x', '1', 'top', '48', '50', '50', '1', null, '1', 'lashen', 'default', '2012-02-29 00:00:00', '2012-02-29 00:00:00', '0.0.0.0', '2017-03-30 22:17:32', '127.0.0.1', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('2', 'test123', '7c4a8d09ca3762af61e59520943dc26494f8941b', '7c4a8d09ca3762af61e59520943dc26494f8941b', '0', null, '4,8', '5,6,7,8,8,11,11,12,14,13', null, '', null, null, 'x', '1', 'right', '48', '50', '50', '8', null, '1', 'juzhong', 'default', '2017-03-01 20:57:55', '2017-03-27 23:14:33', '127.0.0.1', '2017-03-30 22:17:48', '127.0.0.1', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('3', 'test1234', '7c4a8d09ca3762af61e59520943dc26494f8941b', '123456', '0', null, '4', '18,19', null, null, null, null, 'x', '1', 'top', '48', '50', '50', '1', null, '1', 'juzhong', 'default', '2017-03-29 23:52:47', null, null, '2017-03-30 00:03:49', '127.0.0.1', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('4', 'test12345', '7c4a8d09ca3762af61e59520943dc26494f8941b', '123456', '0', null, null, '20,21', null, null, null, null, 'x', '1', 'top', '48', '50', '50', '1', null, '1', 'juzhong', 'default', '2017-03-30 22:13:43', null, null, '2017-03-30 22:13:48', '127.0.0.1', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `tb_member_app`
-- ----------------------------
DROP TABLE IF EXISTS `tb_member_app`;
CREATE TABLE `tb_member_app` (
  `tbid` bigint(20) NOT NULL AUTO_INCREMENT,
  `realid` bigint(20) DEFAULT '0' COMMENT '真实id',
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '图标名称',
  `icon` tinytext COLLATE utf8_unicode_ci COMMENT '图标图片',
  `url` tinytext COLLATE utf8_unicode_ci COMMENT '应用地址',
  `type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '应用类型',
  `width` int(11) DEFAULT NULL COMMENT '窗口宽度',
  `height` int(11) DEFAULT NULL COMMENT '窗口高度',
  `isresize` tinyint(11) DEFAULT NULL COMMENT '是否能对窗口进行拉伸',
  `isopenmax` tinyint(4) DEFAULT NULL COMMENT '是否打开直接最大化',
  `issetbar` tinyint(4) DEFAULT NULL COMMENT '窗口是否有评分和介绍按钮',
  `isflash` tinyint(4) DEFAULT NULL COMMENT '是否为flash应用',
  `ext` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '扩展名',
  `size` int(11) DEFAULT NULL COMMENT '文件大小',
  `dt` datetime DEFAULT NULL COMMENT '创建时间',
  `lastdt` datetime DEFAULT NULL COMMENT '最后修改时间',
  `folder_id` bigint(20) DEFAULT '0' COMMENT '文件夹id',
  `member_id` bigint(20) DEFAULT NULL COMMENT '用户id',
  PRIMARY KEY (`tbid`)
) ENGINE=InnoDB AUTO_INCREMENT=846746964997406721 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
--  Records of `tb_member_app`
-- ----------------------------
BEGIN;
INSERT INTO `tb_member_app` VALUES ('2', '52', '有道在线词典', '/static/uploads/shortcut/20130505/1367738149614.png', null, 'window', '560', '560', '0', '0', '1', '0', null, null, '2015-11-01 20:59:16', '2015-11-01 20:59:16', '0', '1'), ('3', '24', '愚人节整同学', '/static/uploads/shortcut/20130505/13677353829381.png', null, 'window', '820', '680', '1', '0', '1', '1', null, null, '2015-11-01 21:17:29', '2015-11-01 21:17:29', '0', '1'), ('6', '12', '时钟', '/static/img/ui/system-shapes.png', null, 'widget', '130', '160', '0', '0', '1', '0', null, null, '2017-03-01 21:49:06', '2017-03-01 21:49:06', '0', '2'), ('7', '56', '新应用test', '/static/img/ui/system-star.png', null, 'window', '120', '80', '1', '0', '1', '0', null, null, '2017-03-01 21:57:32', '2017-03-01 21:57:32', '0', '2'), ('8', '55', '阴历阳历转换', '/static/uploads/shortcut/20130505/13677388786.png', null, 'window', '570', '470', '0', '0', '1', '0', null, null, '2017-03-28 23:15:46', '2017-03-28 23:15:46', '0', '2'), ('9', '39', '冷酷校草恋上我', '/static/uploads/shortcut/20130505/13677367421113.png', null, 'window', '1000', '650', '1', '0', '1', '0', null, null, '2017-03-28 23:29:49', '2017-03-28 23:29:49', '0', '2'), ('10', '37', '极品小员工', '/static/uploads/shortcut/20130505/13677366172043.png', null, 'window', '1000', '650', '1', '0', '1', '0', null, null, '2017-03-28 23:32:33', '2017-03-28 23:32:34', '0', '2'), ('11', '54', '秒表计时器', '/static/uploads/shortcut/20130505/13677387064869.png', null, 'window', '580', '440', '0', '0', '1', '0', null, null, '2017-03-28 23:38:59', '2017-03-28 23:39:00', '0', '2'), ('12', '41', '天气预报', '/static/uploads/shortcut/20130505/13677369315643.png', null, 'window', '420', '680', '1', '0', '1', '0', null, null, '2017-03-28 23:38:02', '2017-03-28 23:38:02', '0', '2'), ('13', '14', '日历', '/static/uploads/shortcut/20130505/13677342114330.png', null, 'window', '800', '720', '1', '0', '1', '0', null, null, '2017-03-29 22:20:32', '2017-03-29 22:20:33', '0', '2'), ('14', '55', '阴历阳历转换', '/static/uploads/shortcut/20130505/13677388786.png', null, 'window', '570', '470', '0', '0', '1', '0', null, null, '2017-03-29 23:53:04', '2017-03-29 23:53:04', '0', '3'), ('15', '14', '日历', '/static/uploads/shortcut/20130505/13677342114330.png', null, 'window', '800', '720', '1', '0', '1', '0', null, null, '2017-03-29 23:53:23', '2017-03-29 23:53:23', '0', '3'), ('16', '54', '秒表计时器', '/static/uploads/shortcut/20130505/13677387064869.png', null, 'window', '580', '440', '0', '0', '1', '0', null, null, '2017-03-29 23:53:32', '2017-03-29 23:53:32', '0', '3'), ('17', '53', '交通标志', '/static/uploads/shortcut/20130505/13677384429066.png', null, 'window', '600', '700', '0', '0', '1', '1', null, null, '2017-03-29 23:54:25', '2017-03-29 23:54:25', '0', '3'), ('18', '52', '有道在线词典', '/static/uploads/shortcut/20130505/1367738149614.png', null, 'window', '560', '560', '0', '0', '1', '0', null, null, '2017-03-29 23:55:14', '2017-03-29 23:55:14', '0', '3'), ('19', '56', '新应用test', '/static/img/ui/system-star.png', null, 'window', '570', '470', '1', '0', '1', '0', null, null, '2017-03-30 20:41:49', '2017-03-30 20:41:49', '0', '3'), ('20', '55', '阴历阳历转换', '/static/uploads/shortcut/20130505/13677388786.png', null, 'window', '570', '470', '0', '0', '1', '0', null, null, '2017-03-30 22:14:19', '2017-03-30 22:14:19', '0', '4'), ('21', '14', '日历', '/static/uploads/shortcut/20130505/13677342114330.png', null, 'window', '800', '720', '1', '0', '1', '0', null, null, '2017-03-30 22:16:54', '2017-03-30 22:16:54', '0', '4');
COMMIT;

-- ----------------------------
--  Table structure for `tb_permission`
-- ----------------------------
DROP TABLE IF EXISTS `tb_permission`;
CREATE TABLE `tb_permission` (
  `tbid` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '权限名称',
  `apps_id` longtext COLLATE utf8_unicode_ci COMMENT '权限关联应用id，用","相连',
  PRIMARY KEY (`tbid`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
--  Records of `tb_permission`
-- ----------------------------
BEGIN;
INSERT INTO `tb_permission` VALUES ('1', '平台管理员', '1,2,3,4,5'), ('2', '应用管理员', '1'), ('3', '会员管理员', '3'), ('4', '网站设置管理员', '2'), ('5', '类目管理员', '5');
COMMIT;

-- ----------------------------
--  Table structure for `tb_pwallpaper`
-- ----------------------------
DROP TABLE IF EXISTS `tb_pwallpaper`;
CREATE TABLE `tb_pwallpaper` (
  `tbid` bigint(20) NOT NULL AUTO_INCREMENT,
  `url` tinytext COLLATE utf8_unicode_ci COMMENT '壁纸地址',
  `width` int(11) DEFAULT NULL COMMENT '壁纸宽度',
  `height` int(11) DEFAULT NULL COMMENT '壁纸高度',
  `member_id` bigint(20) DEFAULT NULL COMMENT '用户id',
  PRIMARY KEY (`tbid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
--  Table structure for `tb_setting`
-- ----------------------------
DROP TABLE IF EXISTS `tb_setting`;
CREATE TABLE `tb_setting` (
  `tbid` bigint(20) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci COMMENT '网站标题',
  `description` text COLLATE utf8_unicode_ci COMMENT '网站描述',
  `keywords` text COLLATE utf8_unicode_ci COMMENT '网站关键字',
  `dock` longtext COLLATE utf8_unicode_ci COMMENT '[应用码头]应用id，用","相连',
  `desk1` longtext COLLATE utf8_unicode_ci COMMENT '[桌面1]应用id，用","相连',
  `desk2` longtext COLLATE utf8_unicode_ci COMMENT '[桌面2]应用id，用","相连',
  `desk3` longtext COLLATE utf8_unicode_ci COMMENT '[桌面3]应用id，用","相连',
  `desk4` longtext COLLATE utf8_unicode_ci COMMENT '[桌面4]应用id，用","相连',
  `desk5` longtext COLLATE utf8_unicode_ci COMMENT '[桌面5]应用id，用","相连',
  `desk` tinyint(1) DEFAULT '1' COMMENT '默认显示第几桌面',
  `appxy` varchar(255) COLLATE utf8_unicode_ci DEFAULT 'x' COMMENT '图标排列方式，x（横向排列）y（纵向排列）',
  `appsize` int(11) DEFAULT '48' COMMENT '图标尺寸',
  `appverticalspacing` int(11) DEFAULT '50' COMMENT '图标垂直间距',
  `apphorizontalspacing` int(11) DEFAULT '50' COMMENT '图标水平间距',
  `dockpos` varchar(255) COLLATE utf8_unicode_ci DEFAULT 'top' COMMENT '应用码头位置，top（顶部）left（左侧）right（右侧）none（隐藏）',
  `skin` varchar(255) COLLATE utf8_unicode_ci DEFAULT 'default' COMMENT '窗口皮肤',
  `wallpaper_id` int(11) DEFAULT '1',
  `wallpapertype` varchar(255) COLLATE utf8_unicode_ci DEFAULT 'juzhong' COMMENT '壁纸显示方式，tianchong（填充）shiying（适应）pingpu（平铺）lashen（拉伸）juzhong（居中）',
  `isforcedlogin` tinyint(1) DEFAULT '1' COMMENT '是否开启强制登录，1开启0不开启',
  PRIMARY KEY (`tbid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
--  Records of `tb_setting`
-- ----------------------------
BEGIN;
INSERT INTO `tb_setting` VALUES ('1', 'HoorayOS桌面应用框架', 'HoorayOS是一套web桌面应用框架，你可以用它开发出类似于Q+web这类的桌面应用网站，也可以在它的基础上二次开发出适合项目的桌面式管理系统。', 'HoorayOS,web桌面,免费开源,桌面管理系统', '14', '55,54,53,52,51', '50,49,48,47,46', '45,44,43,41,42', '30,29,28,27,26', '20,19,18,17,16', '1', 'x', '32', '50', '50', 'top', 'default', '1', 'juzhong', '0');
COMMIT;

-- ----------------------------
--  Table structure for `tb_wallpaper`
-- ----------------------------
DROP TABLE IF EXISTS `tb_wallpaper`;
CREATE TABLE `tb_wallpaper` (
  `tbid` bigint(20) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '壁纸名称',
  `url` tinytext COLLATE utf8_unicode_ci COMMENT '壁纸地址',
  `width` int(11) DEFAULT NULL COMMENT '壁纸宽度',
  `height` int(11) DEFAULT NULL COMMENT '壁纸高度',
  PRIMARY KEY (`tbid`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
--  Records of `tb_wallpaper`
-- ----------------------------
BEGIN;
INSERT INTO `tb_wallpaper` VALUES ('1', '壁纸1', '/static/img/wallpaper/wallpaper1.jpg', '1920', '1080'), ('2', '壁纸2', '/static/img/wallpaper/wallpaper2.jpg', '1920', '1080'), ('3', '壁纸3', '/static/img/wallpaper/wallpaper3.jpg', '1920', '1080'), ('4', '壁纸4', '/static/img/wallpaper/wallpaper4.jpg', '1920', '1080'), ('5', '壁纸5', '/static/img/wallpaper/wallpaper5.jpg', '1920', '1080'), ('6', '壁纸6', '/static/img/wallpaper/wallpaper6.jpg', '1920', '1080'), ('7', '壁纸7', '/static/img/wallpaper/wallpaper7.jpg', '1920', '1080'), ('8', '壁纸8', '/static/img/wallpaper/wallpaper8.jpg', '1920', '1080'), ('9', '壁纸9', '/static/img/wallpaper/wallpaper9.jpg', '1920', '1080');
COMMIT;

-- ----------------------------
--  Table structure for `user`
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` bigint(20) NOT NULL COMMENT '主键ID',
  `loginName` varchar(30) NOT NULL COMMENT '登录名称',
  `password` varchar(32) NOT NULL COMMENT '密码',
  `email` varchar(60) DEFAULT NULL COMMENT '邮箱',
  `type` smallint(6) NOT NULL DEFAULT '0' COMMENT '0、普通用户 1、管理员',
  `status` smallint(6) NOT NULL DEFAULT '1' COMMENT '0、禁用 1、正常',
  `crTime` datetime NOT NULL COMMENT '创建时间',
  `lastTime` datetime NOT NULL COMMENT '最后登录时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户表';

-- ----------------------------
--  Records of `user`
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES ('1', 'admin', 'b9140469ac5d2a70d86a583e9095ad6f', null, '0', '1', '2016-04-17 18:52:26', '2016-04-17 18:52:26'), ('2', 'test', 'd227f9edb541169068b11221869a014a', null, '0', '1', '2016-04-14 18:22:58', '2016-04-14 18:22:58'), ('415112286823251968', 'abc', 'c4c99e1a5bd140d138ad0863bf59acb3', null, '0', '1', '2016-04-15 20:43:43', '2016-04-15 20:43:43'), ('415112325381488640', 'def', '94e5398201cd9452b1e667044debcd10', null, '0', '1', '2016-04-15 20:43:53', '2016-04-15 20:43:53');
COMMIT;

-- ----------------------------
--  Table structure for `user_role`
-- ----------------------------
DROP TABLE IF EXISTS `user_role`;
CREATE TABLE `user_role` (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `uid` bigint(20) NOT NULL COMMENT '用户ID',
  `rid` bigint(20) NOT NULL COMMENT '角色ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户角色表';

-- ----------------------------
--  Records of `user_role`
-- ----------------------------
BEGIN;
INSERT INTO `user_role` VALUES ('1', '1', '1'), ('2', '2', '2');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
